﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="sp_wsat" targetNamespace="http://tempuri.org/sp_wsat.xsd" xmlns:mstns="http://tempuri.org/sp_wsat.xsd" xmlns="http://tempuri.org/sp_wsat.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="DashboardTableAdapter" GeneratorFunctionsComponentClassName="DashboardTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="DashboardTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="dbMyCMSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dbMyCMSConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.dbMyCMSConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="sp_wsat_UsersTableAdapter" GeneratorDataComponentClassName="sp_wsat_UsersTableAdapter" Name="sp_wsat_Users" UserDataComponentName="sp_wsat_UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.sp_wsat_GetUsersByIsApproved" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="sp_wsat_GetUsersByIsApproved" GetMethodModifier="Public" GetMethodName="sp_wsat_GetUsersByIsApproved" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="sp_wsat_GetUsersByIsApproved" UserSourceName="sp_wsat_GetUsersByIsApproved">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.sp_wsat_GetUsersByIsApproved</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RowNumber" DataSetColumn="RowNumber" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="IsApproved" DataSetColumn="IsApproved" />
              <Mapping SourceColumn="IsLockedOut" DataSetColumn="IsLockedOut" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="LastLoginDate" DataSetColumn="LastLoginDate" />
              <Mapping SourceColumn="LastActivityDate" DataSetColumn="LastActivityDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.sp_wsat_GetUsersByIsLockedOut" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="sp_wsat_GetUsersByIsLockedOut" GetMethodModifier="Public" GetMethodName="sp_wsat_GetUsersByIsLockedOut" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="sp_wsat_GetUsersByIsLockedOut" UserSourceName="sp_wsat_GetUsersByIsLockedOut">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.sp_wsat_GetUsersByIsLockedOut</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.sp_wsat_GetUsersByName" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="sp_wsat_GetUsersByName" GetMethodModifier="Public" GetMethodName="sp_wsat_GetUsersByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="sp_wsat_GetUsersByName" UserSourceName="sp_wsat_GetUsersByName">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.sp_wsat_GetUsersByName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.sp_wsat_GetUsersByRole" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="sp_wsat_GetUsersByRole" GetMethodModifier="Public" GetMethodName="sp_wsat_GetUsersByRole" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="sp_wsat_GetUsersByRole" UserSourceName="sp_wsat_GetUsersByRole">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.sp_wsat_GetUsersByRole</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.sp_wsat_GetUsersBySearch" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="sp_wsat_GetUsersBySearch" GetMethodModifier="Public" GetMethodName="sp_wsat_GetUsersBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="sp_wsat_GetUsersBySearch" UserSourceName="sp_wsat_GetUsersBySearch">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.sp_wsat_GetUsersBySearch</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@startRowIndex" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@maximumRows" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="TotalNumberOfUsersByIsApproved" Modifier="Public" Name="TotalNumberOfUsersByIsApproved" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="TotalNumberOfUsersByIsApproved">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) FROM aspnet_Membership WHERE (IsApproved = 0)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="TotalNumberOfUsersByIsLockedOut" Modifier="Public" Name="TotalNumberOfUsersByIsLockedOut" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="TotalNumberOfUsersByIsLockedOut">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) FROM aspnet_Membership WHERE (IsLockedOut = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="TotalNumberOfUsersByName" Modifier="Public" Name="TotalNumberOfUsersByName" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="TotalNumberOfUsersByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) FROM aspnet_users where UserName like @UserName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserName" ColumnName="UserName" DataSourceName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.aspnet_Users" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy5" GeneratorSourceName="TotalNumberOfUsersByNameOrRole" Modifier="Public" Name="TotalNumberOfUsersByNameOrRole" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="TotalNumberOfUsersByNameOrRole">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>
                      SELECT COUNT(*) FROM aspnet_Roles INNER JOIN aspnet_UsersInRoles ON aspnet_Roles.RoleId = aspnet_UsersInRoles.RoleId INNER JOIN aspnet_Users ON aspnet_UsersInRoles.UserId = aspnet_Users.UserId
                      WHERE (aspnet_Users.UserName LIKE @UserName) OR (aspnet_Roles.RoleName = @RoleName)
                    </CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserName" ColumnName="UserName" DataSourceName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.aspnet_Users" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="RoleName" ColumnName="RoleName" DataSourceName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.aspnet_Roles" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="TotalNumberOfUsersByRole" Modifier="Public" Name="TotalNumberOfUsersByRole" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="TotalNumberOfUsersByRole">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) FROM aspnet_Roles INNER JOIN aspnet_UsersInRoles ON aspnet_Roles.RoleId =aspnet_UsersInRoles.RoleId WHERE (aspnet_Roles.RoleName = @RoleName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="RoleName" ColumnName="RoleName" DataSourceName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.aspnet_Roles" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="TotalNumberOfUsersBySearch" Modifier="Public" Name="TotalNumberOfUsersBySearch" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="TotalNumberOfUsersBySearch">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId WHERE (aspnet_Membership.Email LIKE N'%' + @Email + N'%') OR (aspnet_Users.UserName LIKE N'%' + @UserName + N'%') OR (aspnet_Membership.Email LIKE N'%' + @Email + N'%') AND (aspnet_Users.UserName LIKE N'%' + @UserName + N'%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Email" ColumnName="Email" DataSourceName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.aspnet_Membership" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserName" ColumnName="UserName" DataSourceName="[C:\USERS\TAMAS\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MYCMSJQ\APP_DATA\DBMYCMS.MDF].dbo.aspnet_Users" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="wsat_RolesTableAdapter" GeneratorDataComponentClassName="wsat_RolesTableAdapter" Name="wsat_Roles" UserDataComponentName="wsat_RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectName="dbo.aspnet_Roles" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="wsat_GetRoles" GetMethodModifier="Public" GetMethodName="wsat_GetRoles" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="wsat_GetRoles" UserSourceName="wsat_GetRoles">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        RoleName, RoleId
FROM            aspnet_Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RoleName" DataSetColumn="RoleName" />
              <Mapping SourceColumn="RoleId" DataSetColumn="RoleId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="wsat_DashRegistrationsTableAdapter" GeneratorDataComponentClassName="wsat_DashRegistrationsTableAdapter" Name="wsat_DashRegistrations" UserDataComponentName="wsat_DashRegistrationsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetCountLast30Days" GetMethodModifier="Public" GetMethodName="GetCountLast30Days" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetCountLast30Days" UserSourceName="GetCountLast30Days">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(UserId) AS last30Days FROM aspnet_Membership WHERE (CreateDate &gt; GETDATE() - 30)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="last30Days" DataSetColumn="last30Days" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetCountLast60Days" GetMethodModifier="Public" GetMethodName="GetCountLast60Days" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCountLast60Days" UserSourceName="GetCountLast60Days">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(UserId) AS last60Days FROM aspnet_Membership WHERE (CreateDate &gt; GETDATE() - 60) AND (CreateDate &lt; GETDATE() - 30)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetCountLast90Days" GetMethodModifier="Public" GetMethodName="GetCountLast90Days" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCountLast90Days" UserSourceName="GetCountLast90Days">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(UserId) AS last90Days FROM aspnet_Membership WHERE (CreateDate &gt; GETDATE() - 90) AND (CreateDate &lt; GETDATE() - 60)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetCountOver90Days" GetMethodModifier="Public" GetMethodName="GetCountOver90Days" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCountOver90Days" UserSourceName="GetCountOver90Days">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(UserId) AS Over90Days FROM aspnet_Membership WHERE (CreateDate &lt; GETDATE() - 90)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="wsat_DashLatestLoginsTableAdapter" GeneratorDataComponentClassName="wsat_DashLatestLoginsTableAdapter" Name="wsat_DashLatestLogins" UserDataComponentName="wsat_DashLatestLoginsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetLatestLogins" GetMethodModifier="Public" GetMethodName="GetLatestLogins" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetLatestLogins" UserSourceName="GetLatestLogins">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TOP (5) aspnet_Users.UserName, aspnet_Membership.LastLoginDate FROM aspnet_Users INNER JOIN aspnet_Membership ON aspnet_Users.UserId = aspnet_Membership.UserId AND aspnet_Users.UserId = aspnet_Membership.UserId ORDER BY aspnet_Membership.LastLoginDate DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="LastLoginDate" DataSetColumn="LastLoginDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="wsat_DashNewestMembersTableAdapter" GeneratorDataComponentClassName="wsat_DashNewestMembersTableAdapter" Name="wsat_DashNewestMembers" UserDataComponentName="wsat_DashNewestMembersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetNewestMembers" GetMethodModifier="Public" GetMethodName="GetNewestMembers" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetNewestMembers" UserSourceName="GetNewestMembers">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TOP (5) aspnet_Users.UserName, aspnet_Membership.CreateDate FROM aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId AND aspnet_Membership.UserId = aspnet_Users.UserId</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="wsat_DashStatusTableAdapter" GeneratorDataComponentClassName="wsat_DashStatusTableAdapter" Name="wsat_DashStatus" UserDataComponentName="wsat_DashStatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetCountLockedOut" GetMethodModifier="Public" GetMethodName="GetCountLockedOut" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetCountLockedOut" UserSourceName="GetCountLockedOut">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) AS LockedOut FROM aspnet_Membership WHERE (IsLockedOut = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LockedOut" DataSetColumn="LockedOut" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetCountUnapproved" GetMethodModifier="Public" GetMethodName="GetCountUnapproved" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCountUnapproved" UserSourceName="GetCountUnapproved">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) AS Unapproved FROM aspnet_Membership WHERE (IsApproved = 0)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetTotalCount" GetMethodModifier="Public" GetMethodName="GetTotalCount" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetTotalCount" UserSourceName="GetTotalCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) AS TotalCount FROM aspnet_Membership</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="wsat_DashLoggedInTableAdapter" GeneratorDataComponentClassName="wsat_DashLoggedInTableAdapter" Name="wsat_DashLoggedIn" UserDataComponentName="wsat_DashLoggedInTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetCountLoggedIn30" GetMethodModifier="Public" GetMethodName="GetCountLoggedIn30" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetCountLoggedIn30" UserSourceName="GetCountLoggedIn30">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) AS LastLoggedIn30 FROM aspnet_Membership WHERE (LastLoginDate &gt; GETDATE() - 30)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LastLoggedIn30" DataSetColumn="LastLoggedIn30" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetCountLoggedIn60" GetMethodModifier="Public" GetMethodName="GetCountLoggedIn60" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCountLoggedIn60" UserSourceName="GetCountLoggedIn60">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) AS LastLoggedIn60 FROM aspnet_Membership WHERE (LastLoginDate &gt; GETDATE() - 60) AND (LastLoginDate &lt; GETDATE() - 30)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetCountLoggedIn90" GetMethodModifier="Public" GetMethodName="GetCountLoggedIn90" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCountLoggedIn90" UserSourceName="GetCountLoggedIn90">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) AS LastLoggedIn90 FROM aspnet_Membership WHERE (LastLoginDate &gt; GETDATE() - 90) AND (LastLoginDate &lt; GETDATE() - 60)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetCountLoggedInOver90" GetMethodModifier="Public" GetMethodName="GetCountLoggedInOver90" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCountLoggedInOver90" UserSourceName="GetCountLoggedInOver90">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) AS LastLoggedInOver90 FROM aspnet_Membership WHERE (LastLoginDate &lt; GETDATE() - 90)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="wsat_DashRolesTableAdapter" GeneratorDataComponentClassName="wsat_DashRolesTableAdapter" Name="wsat_DashRoles" UserDataComponentName="wsat_DashRolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetCountRoles" GetMethodModifier="Public" GetMethodName="GetCountRoles" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetCountRoles" UserSourceName="GetCountRoles">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) AS RoleCount FROM aspnet_Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RoleCount" DataSetColumn="RoleCount" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbMyCMSConnectionString (Web.config)" DbObjectName="dbo.aspnet_Roles" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetRoles" GetMethodModifier="Public" GetMethodName="GetRoles" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetRoles" UserSourceName="GetRoles">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TOP (5) RoleName FROM aspnet_Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="sp_wsat" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="sp_wsat" msprop:Generator_UserDSName="sp_wsat">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="sp_wsat_Users" msprop:Generator_UserTableName="sp_wsat_Users" msprop:Generator_RowEvArgName="sp_wsat_UsersRowChangeEvent" msprop:Generator_TableVarName="tablesp_wsat_Users" msprop:Generator_TablePropName="sp_wsat_Users" msprop:Generator_RowDeletingName="sp_wsat_UsersRowDeleting" msprop:Generator_RowChangingName="sp_wsat_UsersRowChanging" msprop:Generator_RowDeletedName="sp_wsat_UsersRowDeleted" msprop:Generator_TableClassName="sp_wsat_UsersDataTable" msprop:Generator_RowChangedName="sp_wsat_UsersRowChanged" msprop:Generator_RowEvHandlerName="sp_wsat_UsersRowChangeEventHandler" msprop:Generator_RowClassName="sp_wsat_UsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RowNumber" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRowNumber" msprop:Generator_ColumnPropNameInRow="RowNumber" msprop:Generator_ColumnPropNameInTable="RowNumberColumn" msprop:Generator_UserColumnName="RowNumber" type="xs:long" minOccurs="0" />
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsApproved" msprop:Generator_ColumnVarNameInTable="columnIsApproved" msprop:Generator_ColumnPropNameInRow="IsApproved" msprop:Generator_ColumnPropNameInTable="IsApprovedColumn" msprop:Generator_UserColumnName="IsApproved" type="xs:boolean" />
              <xs:element name="IsLockedOut" msprop:Generator_ColumnVarNameInTable="columnIsLockedOut" msprop:Generator_ColumnPropNameInRow="IsLockedOut" msprop:Generator_ColumnPropNameInTable="IsLockedOutColumn" msprop:Generator_UserColumnName="IsLockedOut" type="xs:boolean" />
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
              <xs:element name="LastLoginDate" msprop:Generator_ColumnVarNameInTable="columnLastLoginDate" msprop:Generator_ColumnPropNameInRow="LastLoginDate" msprop:Generator_ColumnPropNameInTable="LastLoginDateColumn" msprop:Generator_UserColumnName="LastLoginDate" type="xs:dateTime" />
              <xs:element name="LastActivityDate" msprop:Generator_ColumnVarNameInTable="columnLastActivityDate" msprop:Generator_ColumnPropNameInRow="LastActivityDate" msprop:Generator_ColumnPropNameInTable="LastActivityDateColumn" msprop:Generator_UserColumnName="LastActivityDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="wsat_Roles" msprop:Generator_UserTableName="wsat_Roles" msprop:Generator_RowEvArgName="wsat_RolesRowChangeEvent" msprop:Generator_TableVarName="tablewsat_Roles" msprop:Generator_TablePropName="wsat_Roles" msprop:Generator_RowDeletingName="wsat_RolesRowDeleting" msprop:Generator_RowChangingName="wsat_RolesRowChanging" msprop:Generator_RowDeletedName="wsat_RolesRowDeleted" msprop:Generator_TableClassName="wsat_RolesDataTable" msprop:Generator_RowChangedName="wsat_RolesRowChanged" msprop:Generator_RowEvHandlerName="wsat_RolesRowChangeEventHandler" msprop:Generator_RowClassName="wsat_RolesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RoleName" msprop:Generator_ColumnVarNameInTable="columnRoleName" msprop:Generator_ColumnPropNameInRow="RoleName" msprop:Generator_ColumnPropNameInTable="RoleNameColumn" msprop:Generator_UserColumnName="RoleName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RoleId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnRoleId" msprop:Generator_ColumnPropNameInRow="RoleId" msprop:Generator_ColumnPropNameInTable="RoleIdColumn" msprop:Generator_UserColumnName="RoleId" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="wsat_DashRegistrations" msprop:Generator_TableClassName="wsat_DashRegistrationsDataTable" msprop:Generator_TableVarName="tablewsat_DashRegistrations" msprop:Generator_TablePropName="wsat_DashRegistrations" msprop:Generator_RowDeletingName="wsat_DashRegistrationsRowDeleting" msprop:Generator_UserTableName="wsat_DashRegistrations" msprop:Generator_RowChangingName="wsat_DashRegistrationsRowChanging" msprop:Generator_RowEvHandlerName="wsat_DashRegistrationsRowChangeEventHandler" msprop:Generator_RowDeletedName="wsat_DashRegistrationsRowDeleted" msprop:Generator_RowEvArgName="wsat_DashRegistrationsRowChangeEvent" msprop:Generator_RowChangedName="wsat_DashRegistrationsRowChanged" msprop:Generator_RowClassName="wsat_DashRegistrationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="last30Days" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnlast30Days" msprop:Generator_ColumnPropNameInRow="last30Days" msprop:Generator_ColumnPropNameInTable="last30DaysColumn" msprop:Generator_UserColumnName="last30Days" type="xs:int" minOccurs="0" />
              <xs:element name="last60Days" msprop:Generator_ColumnVarNameInTable="columnlast60Days" msprop:Generator_ColumnPropNameInRow="last60Days" msprop:Generator_ColumnPropNameInTable="last60DaysColumn" msprop:Generator_UserColumnName="last60Days" type="xs:string" minOccurs="0" />
              <xs:element name="last90Days" msprop:Generator_ColumnVarNameInTable="columnlast90Days" msprop:Generator_ColumnPropNameInRow="last90Days" msprop:Generator_ColumnPropNameInTable="last90DaysColumn" msprop:Generator_UserColumnName="last90Days" type="xs:string" minOccurs="0" />
              <xs:element name="Over90Days" msprop:Generator_ColumnVarNameInTable="columnOver90Days" msprop:Generator_ColumnPropNameInRow="Over90Days" msprop:Generator_ColumnPropNameInTable="Over90DaysColumn" msprop:Generator_UserColumnName="Over90Days" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="wsat_DashLatestLogins" msprop:Generator_TableClassName="wsat_DashLatestLoginsDataTable" msprop:Generator_TableVarName="tablewsat_DashLatestLogins" msprop:Generator_TablePropName="wsat_DashLatestLogins" msprop:Generator_RowDeletingName="wsat_DashLatestLoginsRowDeleting" msprop:Generator_UserTableName="wsat_DashLatestLogins" msprop:Generator_RowChangingName="wsat_DashLatestLoginsRowChanging" msprop:Generator_RowEvHandlerName="wsat_DashLatestLoginsRowChangeEventHandler" msprop:Generator_RowDeletedName="wsat_DashLatestLoginsRowDeleted" msprop:Generator_RowEvArgName="wsat_DashLatestLoginsRowChangeEvent" msprop:Generator_RowChangedName="wsat_DashLatestLoginsRowChanged" msprop:Generator_RowClassName="wsat_DashLatestLoginsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastLoginDate" msprop:Generator_ColumnVarNameInTable="columnLastLoginDate" msprop:Generator_ColumnPropNameInRow="LastLoginDate" msprop:Generator_ColumnPropNameInTable="LastLoginDateColumn" msprop:Generator_UserColumnName="LastLoginDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="wsat_DashNewestMembers" msprop:Generator_TableClassName="wsat_DashNewestMembersDataTable" msprop:Generator_TableVarName="tablewsat_DashNewestMembers" msprop:Generator_TablePropName="wsat_DashNewestMembers" msprop:Generator_RowDeletingName="wsat_DashNewestMembersRowDeleting" msprop:Generator_UserTableName="wsat_DashNewestMembers" msprop:Generator_RowChangingName="wsat_DashNewestMembersRowChanging" msprop:Generator_RowEvHandlerName="wsat_DashNewestMembersRowChangeEventHandler" msprop:Generator_RowDeletedName="wsat_DashNewestMembersRowDeleted" msprop:Generator_RowEvArgName="wsat_DashNewestMembersRowChangeEvent" msprop:Generator_RowChangedName="wsat_DashNewestMembersRowChanged" msprop:Generator_RowClassName="wsat_DashNewestMembersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" msprop:Generator_UserColumnName="CreateDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="wsat_DashStatus" msprop:Generator_TableClassName="wsat_DashStatusDataTable" msprop:Generator_TableVarName="tablewsat_DashStatus" msprop:Generator_TablePropName="wsat_DashStatus" msprop:Generator_RowDeletingName="wsat_DashStatusRowDeleting" msprop:Generator_UserTableName="wsat_DashStatus" msprop:Generator_RowChangingName="wsat_DashStatusRowChanging" msprop:Generator_RowEvHandlerName="wsat_DashStatusRowChangeEventHandler" msprop:Generator_RowDeletedName="wsat_DashStatusRowDeleted" msprop:Generator_RowEvArgName="wsat_DashStatusRowChangeEvent" msprop:Generator_RowChangedName="wsat_DashStatusRowChanged" msprop:Generator_RowClassName="wsat_DashStatusRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LockedOut" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnLockedOut" msprop:Generator_ColumnPropNameInRow="LockedOut" msprop:Generator_ColumnPropNameInTable="LockedOutColumn" msprop:Generator_UserColumnName="LockedOut" type="xs:int" minOccurs="0" />
              <xs:element name="Unapproved" msprop:Generator_ColumnVarNameInTable="columnUnapproved" msprop:Generator_ColumnPropNameInRow="Unapproved" msprop:Generator_ColumnPropNameInTable="UnapprovedColumn" msprop:Generator_UserColumnName="Unapproved" type="xs:string" minOccurs="0" />
              <xs:element name="TotalCount" msprop:Generator_ColumnVarNameInTable="columnTotalCount" msprop:Generator_ColumnPropNameInRow="TotalCount" msprop:Generator_ColumnPropNameInTable="TotalCountColumn" msprop:Generator_UserColumnName="TotalCount" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="wsat_DashLoggedIn" msprop:Generator_TableClassName="wsat_DashLoggedInDataTable" msprop:Generator_TableVarName="tablewsat_DashLoggedIn" msprop:Generator_TablePropName="wsat_DashLoggedIn" msprop:Generator_RowDeletingName="wsat_DashLoggedInRowDeleting" msprop:Generator_UserTableName="wsat_DashLoggedIn" msprop:Generator_RowChangingName="wsat_DashLoggedInRowChanging" msprop:Generator_RowEvHandlerName="wsat_DashLoggedInRowChangeEventHandler" msprop:Generator_RowDeletedName="wsat_DashLoggedInRowDeleted" msprop:Generator_RowEvArgName="wsat_DashLoggedInRowChangeEvent" msprop:Generator_RowChangedName="wsat_DashLoggedInRowChanged" msprop:Generator_RowClassName="wsat_DashLoggedInRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LastLoggedIn30" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnLastLoggedIn30" msprop:Generator_ColumnPropNameInRow="LastLoggedIn30" msprop:Generator_ColumnPropNameInTable="LastLoggedIn30Column" msprop:Generator_UserColumnName="LastLoggedIn30" type="xs:int" minOccurs="0" />
              <xs:element name="LastLoggedIn60" msprop:Generator_ColumnVarNameInTable="columnLastLoggedIn60" msprop:Generator_ColumnPropNameInRow="LastLoggedIn60" msprop:Generator_ColumnPropNameInTable="LastLoggedIn60Column" msprop:Generator_UserColumnName="LastLoggedIn60" type="xs:string" minOccurs="0" />
              <xs:element name="LastLoggedIn90" msprop:Generator_ColumnVarNameInTable="columnLastLoggedIn90" msprop:Generator_ColumnPropNameInRow="LastLoggedIn90" msprop:Generator_ColumnPropNameInTable="LastLoggedIn90Column" msprop:Generator_UserColumnName="LastLoggedIn90" type="xs:string" minOccurs="0" />
              <xs:element name="LastLoggedInOver90" msprop:Generator_ColumnVarNameInTable="columnLastLoggedInOver90" msprop:Generator_ColumnPropNameInRow="LastLoggedInOver90" msprop:Generator_ColumnPropNameInTable="LastLoggedInOver90Column" msprop:Generator_UserColumnName="LastLoggedInOver90" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="wsat_DashRoles" msprop:Generator_TableClassName="wsat_DashRolesDataTable" msprop:Generator_TableVarName="tablewsat_DashRoles" msprop:Generator_TablePropName="wsat_DashRoles" msprop:Generator_RowDeletingName="wsat_DashRolesRowDeleting" msprop:Generator_UserTableName="wsat_DashRoles" msprop:Generator_RowChangingName="wsat_DashRolesRowChanging" msprop:Generator_RowEvHandlerName="wsat_DashRolesRowChangeEventHandler" msprop:Generator_RowDeletedName="wsat_DashRolesRowDeleted" msprop:Generator_RowEvArgName="wsat_DashRolesRowChangeEvent" msprop:Generator_RowChangedName="wsat_DashRolesRowChanged" msprop:Generator_RowClassName="wsat_DashRolesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RoleCount" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnRoleCount" msprop:Generator_ColumnPropNameInRow="RoleCount" msprop:Generator_ColumnPropNameInTable="RoleCountColumn" msprop:Generator_UserColumnName="RoleCount" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>